﻿using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace XMFramework.Models
{
    [SugarTable("xmf_production_order_model")]//当和数据库名称不一样可以设置表别名 指定表明
    public class ProductionOrderModel
    {
        //数据是自增需要加上IsIdentity 
        //数据库是主键需要加上IsPrimaryKey 
        //注意：要完全和数据库一致2个属性
        [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
        public int id { get; set; }
        /// <summary>
        /// 订单编号
        /// </summary>
        public string orderCode { get; set; }
        /// <summary>
        /// 合同号
        /// </summary>
        public string contractCode { get; set; }
        /// <summary>
        /// 物料编码
        /// </summary>
        public string materialCode { get; set; }
        /// <summary>
        /// 设备编号
        /// </summary>
        public string deviceCode { get; set; }
        /// <summary>
        /// 工艺编号
        /// </summary>
        public string recipeCode { get; set; }
        /// <summary>
        /// 模具编号
        /// </summary>
        public string moldCode { get; set; }
        /// <summary>
        /// 原料密度
        /// </summary>
        public string epsDensity { get; set; }
        /// <summary>
        /// 每模产品数量
        /// </summary>
        public int singleNumber { get; set; }
        /// <summary>
        /// 已生产产品数量
        /// </summary>
        public int completNumber { get; set; }
        /// <summary>
        /// 任务总数量
        /// </summary>
        public int totalNumber { get; set; }
        /// <summary>
        /// 状态
        /// </summary>
        public string state { get; set; }
        /// <summary>
        /// 完成日期
        /// </summary>
        [SugarColumn(IsNullable = true)]//可以为NULL
        public DateTime completDate { get; set; }
        /// <summary>
        /// 创建日期
        /// </summary>
        public DateTime creationDate { get; set; }


    }
}
